﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="Welcome.aspx.vb" Inherits="ArduinoPlayground.Register1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
        .style1
        {
            text-align: right;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    
<p class="style1">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>

<h2>
    Whats new for today?
    </h2>
<p>
        Hi
        <asp:Label ID="lbl_Name" runat="server" Text="userName"></asp:Label>
        , Welcome back! Scrool down if you need to update you profile!</p>
    <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
    <strong>&nbsp; Most Liked Projects&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
    Top rated Projects&nbsp;&nbsp;
    <br />
    </strong>
    <asp:Chart ID="Chart1" runat="server" DataSourceID="Likes_SqlDataSource">
        <series>
            <asp:Series Name="Series1" XValueMember="Title" YValueMembers="CountOfID">
            </asp:Series>
        </series>
        <chartareas>
            <asp:ChartArea Name="ChartArea1">
            </asp:ChartArea>
        </chartareas>
    </asp:Chart>
&nbsp;&nbsp;&nbsp;
    <asp:Chart ID="Chart2" runat="server" DataSourceID="Rate_SqlDataSource">
        <series>
            <asp:Series Name="Series1" XValueMember="Title" 
                YValueMembers="AverageRating">
            </asp:Series>
        </series>
        <chartareas>
            <asp:ChartArea Name="ChartArea1">
            </asp:ChartArea>
        </chartareas>
    </asp:Chart>
    <asp:SqlDataSource ID="Rate_SqlDataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ArduinoPlaygroundConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:ArduinoPlaygroundConnectionString.ProviderName %>" 
        
        SelectCommand="SELECT TOP 3 [AverageRating], [Title] FROM [AverageProjectRatingView] ORDER BY [AverageRating] DESC">
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="Likes_SqlDataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ArduinoPlaygroundConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:ArduinoPlaygroundConnectionString.ProviderName %>" 
        SelectCommand="SELECT TOP 3 [Title], [CountOfID] FROM [CountLikesView] WHERE ([CountOfID] &gt; ?) ORDER BY [CountOfID] DESC">
        <SelectParameters>
            <asp:Parameter DefaultValue="2" Name="CountOfID" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>

<p>
        &nbsp;</p>
    <p>
        <strong>Update Profile:</strong></p>
    <p>
        First Name:
        <asp:TextBox ID="tb_firstName" runat="server"></asp:TextBox>
    </p>
    <p>
        Last Name:
        <asp:TextBox ID="tb_lastName" runat="server"></asp:TextBox>
    </p>
    <p>
        Profile Avatar:&nbsp;&nbsp;&nbsp; <asp:FileUpload ID="fu_avatar" runat="server" />
    </p>
    <p>
        Date of Birth: DD:
        <asp:DropDownList ID="ddl_DD" runat="server">
            <asp:ListItem>01</asp:ListItem>
            <asp:ListItem>02</asp:ListItem>
            <asp:ListItem>03</asp:ListItem>
            <asp:ListItem>04</asp:ListItem>
            <asp:ListItem>05</asp:ListItem>
            <asp:ListItem>06</asp:ListItem>
            <asp:ListItem>07</asp:ListItem>
            <asp:ListItem>08</asp:ListItem>
            <asp:ListItem>09</asp:ListItem>
            <asp:ListItem>10</asp:ListItem>
            <asp:ListItem>11</asp:ListItem>
            <asp:ListItem>11</asp:ListItem>
            <asp:ListItem>12</asp:ListItem>
            <asp:ListItem>13</asp:ListItem>
            <asp:ListItem>14</asp:ListItem>
            <asp:ListItem>15</asp:ListItem>
            <asp:ListItem>16</asp:ListItem>
            <asp:ListItem>17</asp:ListItem>
            <asp:ListItem>18</asp:ListItem>
            <asp:ListItem>19</asp:ListItem>
            <asp:ListItem>20</asp:ListItem>
            <asp:ListItem>21</asp:ListItem>
            <asp:ListItem>22</asp:ListItem>
            <asp:ListItem>23</asp:ListItem>
            <asp:ListItem>24</asp:ListItem>
            <asp:ListItem>25</asp:ListItem>
            <asp:ListItem>26</asp:ListItem>
            <asp:ListItem>27</asp:ListItem>
            <asp:ListItem>28</asp:ListItem>
            <asp:ListItem>29</asp:ListItem>
            <asp:ListItem>30</asp:ListItem>
            <asp:ListItem>31</asp:ListItem>

        </asp:DropDownList>
&nbsp;MM:
        <asp:DropDownList ID="ddl_MM" runat="server">
            <asp:ListItem>01</asp:ListItem>
            <asp:ListItem>02</asp:ListItem>
            <asp:ListItem>03</asp:ListItem>
            <asp:ListItem>04</asp:ListItem>
            <asp:ListItem>05</asp:ListItem>
            <asp:ListItem>06</asp:ListItem>
            <asp:ListItem>07</asp:ListItem>
            <asp:ListItem>08</asp:ListItem>
            <asp:ListItem>09</asp:ListItem>
            <asp:ListItem>10</asp:ListItem>
            <asp:ListItem>11</asp:ListItem>
            <asp:ListItem>12</asp:ListItem>
        </asp:DropDownList>
&nbsp;YYYY:
        <asp:DropDownList ID="ddl_YYYY" runat="server">
            <asp:ListItem>1987</asp:ListItem>
            <asp:ListItem>1988</asp:ListItem>
            <asp:ListItem>1989</asp:ListItem>
            <asp:ListItem>1990</asp:ListItem>
            <asp:ListItem>1991</asp:ListItem>
            <asp:ListItem>1992</asp:ListItem>
            <asp:ListItem>1993</asp:ListItem>
            <asp:ListItem>1994</asp:ListItem>
            <asp:ListItem>1995</asp:ListItem>
            <asp:ListItem>1996</asp:ListItem>
            <asp:ListItem>1997</asp:ListItem>
            <asp:ListItem>1998</asp:ListItem>
            <asp:ListItem>1999</asp:ListItem>
            <asp:ListItem>2000</asp:ListItem>
            <asp:ListItem>2001</asp:ListItem>
            <asp:ListItem>2002</asp:ListItem>
            <asp:ListItem>2003</asp:ListItem>
            <asp:ListItem>2004</asp:ListItem>
        </asp:DropDownList>
&nbsp;</p>
    <p>
        Occupation: 
        <asp:TextBox ID="tb_Occupation" runat="server"></asp:TextBox>
    </p>
    <p>
        Country:
        <asp:TextBox ID="tb_Country" runat="server"></asp:TextBox>
    </p>
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:Button ID="btn_update" runat="server" Text="Update" />
    </p>
    <br />
</asp:Content>
